select 
	{reprint == $补打$:
		$
			cast(o.id as varchar)+ '(票据补打)'			        	
		$,
	 reprint == $正常$:	
		$
		o.id
		$,
        $$
	} id,
	CONVERT(varchar(100), o.f_fillcard_date, 23) newdata,
	u.f_user_name,		--用户姓名
	u.f_userinfo_id,
	u.f_address,		--用户地址
	'补卡' f_payment,
	o.f_cardfees f_collection,		--实收金额
	o.f_operator,		--收费员
	[dbo].[f_num_chn](o.f_cardfees) f_daxie
from t_fillcard o 
left join 
t_userinfo u
on o.f_userinfo_id = u.f_userinfo_id
where id= '{id}'